if exists (select 1
            from  sysobjects
           where  id = object_id('tmp_dt_user')
            and   type = 'U')
   drop table tmp_dt_user
go

CREATE TABLE [dbo].[tmp_dt_user](
	[xh] [int] IDENTITY(1,1) NOT NULL,
	[user_serial] [int] NULL,
	[user_no] [nvarchar](200) NOT NULL,
	[user_lname] [nvarchar](50) NULL,
	[user_fname] [nvarchar](50) NULL,
	[user_lx] [int] NULL,
	[dep_no] [nvarchar](50) NULL,
	[user_dep] [int] NULL,
	[user_depname] [nvarchar](50) NULL,
	[user_workday] [smalldatetime] NULL,
	[user_duty] [nvarchar](20) NULL,
	[user_card] [nvarchar](20) NULL,
	[user_finger] [nvarchar](10) NULL,
	[user_password] [nvarchar](10) NULL,
	[pwd_begin] [smalldatetime] NULL,
	[pwd_end] [smalldatetime] NULL,
	[user_type] [smallint] NULL,
	[pact_begin] [smalldatetime] NULL,
	[pact_end] [smalldatetime] NULL,
	[user_level] [int] NULL,
	[user_photo] [int] NULL,
	[user_sex] [nvarchar](8) NULL,
	[user_nation] [nvarchar](20) NULL,
	[user_xueli] [nvarchar](20) NULL,
	[user_native] [nvarchar](20) NULL,
	[user_birthday] [smalldatetime] NULL,
	[user_id] [nvarchar](30) NULL,
	[user_post] [nvarchar](20) NULL,
	[user_linkman] [nvarchar](50) NULL,
	[user_telephone] [nvarchar](30) NULL,
	[user_address] [nvarchar](50) NULL,
	[user_email] [nvarchar](50) NULL,
	[user_1] [nvarchar](20) NULL,
	[user_2] [nvarchar](50) NULL,
	[user_bz] [ntext] NULL,
	[kq_rule] [varchar](100) NULL,
	[kq_taoban] [nvarchar](500) NULL,
	[kq_tiaoxiu] [int] NULL,
	[xf_time] [smalldatetime] NULL,
	[xf_jiange] [int] NULL,
	[xf_je] [int] NULL,
	[user_sj] [smalldatetime] NULL,
	[zh] [varchar](200) NULL,
	[card_state] [int] NULL,
	[gxdatetime] [datetime] NULL,
	[face_photo] [varchar](200) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO


